﻿CREATE TABLE [dbo].[App_Menu] (
    [ID]          INT           IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [MID]         VARCHAR (30)  CONSTRAINT [DF_App_Menu_MID] DEFAULT ('') NULL,
    [MName]       NVARCHAR (50) CONSTRAINT [DF_App_Menu_MName] DEFAULT ('') NULL,
    [MPath]       VARCHAR (MAX) CONSTRAINT [DF_App_Menu_MPath] DEFAULT ('') NULL,
    [Msort]       INT           CONSTRAINT [DF_App_Menu_Msort] DEFAULT ((0)) NULL,
    [Mark]        INT           CONSTRAINT [DF_App_Menu_Mark] DEFAULT ((0)) NULL,
    [EntryPeople] NVARCHAR (50) CONSTRAINT [DF_App_Menu_EntryPeople] DEFAULT ('') NULL,
    [EntryTime]   DATETIME      CONSTRAINT [DF_App_Menu_EntryTime] DEFAULT (getdate()) NULL,
    CONSTRAINT [PK_App_Menu] PRIMARY KEY CLUSTERED ([ID] ASC)
);

